As Data is Realtime and no ML model is to be built, so we're avoiding preproprocessing of the data

. All The Numerical Variables **

BOXPLOT SHOWS OUTLIERS INCLUDED IN THE DATASET

2.1 Which channel’s ads do the users like the most? (hint: click through rate or CTR)

focusing on clicks vs impressions graph, Channel SEM brand and APP - Acqusition Android are most liked by the users. As they have high click / impressions.

2.2 What’s the CPI of App channels (APP-Acquisition-Android and APP-Acquisition-iOS) by country and OS?

2.3 In SEM channels, which country has the best conversion rate?

from above graph we can conclude that country S has high conversion Rate as it has maxiumum purchases

2.4 Which Web channel has better CPA?

(Cost Per Action or Acquisition) , (CPA) is calculated by dividing the total cost of conversions by the total number of conversions

CPA of channel SEM brand is better than other channles as, cost of acqusition is less and purchases by customer is moree.

2.5 Identify the top 3 performing channels of each country in terms of ROI.

The basic ROI calculation is: ROI = (Net Profit/Total Cost)*100.

Based on above graph, we can see ROI of all countries are majorly contributed by

1. SEM Brand

2. SEM fligts

3. Web Retargeting

Additional graphs to understand distribution of ROI vs revenue & cost